home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vvbpmoneydet.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  64 lines
  1. /*
  2. This view collects the detail for bills and coins of both the currency accepted and the total money in the cashbox.
  3. */
  4. CREATE OR REPLACE VIEW VVBPMONEYDET  AS 
  5. SELECT vcscurdetail.conversion_num,
  6. vcscurdetail.close_count,
  7. /* */
  8. vcscurdetail.cashbox_glid,
  9. vcscurdetail.cents_$ +vcscurdetail.nickels_$ +
  10.     vcscurdetail.dimes_$ + vcscurdetail.quarters_$ +
  11.     vcscurdetail.halfs_$ + vcscurdetail.sbas_$ +
  12.     vcscurdetail.ones_$ + vcscurdetail.fives_$+ vcscurdetail.tens_$ +
  13.     vcscurdetail.twenties_$ totalcash,
  14. /*vcscurdetail.totalcash,*/
  15. vcuraccdetail.cents_$ +vcuraccdetail.nickels_$ +
  16. vcuraccdetail.dimes_$ + vcuraccdetail.quarters_$ +
  17. vcuraccdetail.halfs_$ +
  18. vcuraccdetail.sbas_$ +
  19. vcuraccdetail.ones_$ +
  20. vcuraccdetail.fives_$+
  21. vcuraccdetail.tens_$ +
  22. vcuraccdetail.twenties_$ probedcash, 
  23. /*vcuraccdetail.probedcash,*/
  24. vcuraccdetail.cents_$,
  25. vcuraccdetail.nickels_$,
  26. vcuraccdetail.dimes_$,
  27. vcuraccdetail.quarters_$,
  28. vcuraccdetail.halfs_$,
  29. vcuraccdetail.sbas_$,
  30. vcuraccdetail.sm_tokens,
  31. vcuraccdetail.lg_tokens,
  32. vcuraccdetail.cents_$ +vcuraccdetail.nickels_$ +
  33. vcuraccdetail.dimes_$ + vcuraccdetail.quarters_$ +
  34. vcuraccdetail.halfs_$ +
  35. vcuraccdetail.sbas_$ coin_total,
  36. vcuraccdetail.ones_$,
  37. vcuraccdetail.fives_$,
  38. vcuraccdetail.tens_$,
  39. vcuraccdetail.twenties_$,
  40. vcuraccdetail.ones_$ +
  41. vcuraccdetail.fives_$+
  42. vcuraccdetail.tens_$ +
  43. vcuraccdetail.twenties_$ bill_total,
  44. vcscurdetail.cents_$ t_cents_$,
  45. vcscurdetail.nickels_$ t_nickels_$,
  46. vcscurdetail.dimes_$ t_dimes_$,
  47. vcscurdetail.quarters_$ t_quarters_$,
  48. vcscurdetail.halfs_$ t_halfs_$,
  49. vcscurdetail.sbas_$ t_sbas_$,
  50. vcscurdetail.sm_tokens t_sm_tokens,
  51. vcscurdetail.lg_tokens t_lg_tokens,
  52. vcscurdetail.cents_$ +vcscurdetail.nickels_$ +
  53.     vcscurdetail.dimes_$ + vcscurdetail.quarters_$ +
  54.     vcscurdetail.halfs_$ + vcscurdetail.sbas_$ t_coin_total,
  55. vcscurdetail.ones_$ t_ones_$,
  56. vcscurdetail.fives_$ t_fives_$,
  57. vcscurdetail.tens_$ t_tens_$,
  58. vcscurdetail.twenties_$ t_twenties_$,
  59. vcscurdetail.ones_$ + vcscurdetail.fives_$+ vcscurdetail.tens_$ +
  60.     vcscurdetail.twenties_$ t_bill_total
  61. FROM vcscurdetail, vcuraccdetail
  62. WHERE vcscurdetail.close_count = vcuraccdetail.close_count (+);
  63.  
  64.